mySQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.active = 1
AND c.deleted = 0
AND a.active = 1
AND a.dele' at line 11 Error occurred while running query:
SELECT c.id_content, c.pubdate, REPLACE(c.title, '&', '|-|') AS title, c.brief, CONCAT('/espanol/noticias/',c.url,'.html') AS url,
IF(LENGTH(c.thumbnail)>0, CONCAT('uploads/news/',c.thumbnail), 'images/th-expo-1.png') AS thumbnail,
GROUP_CONCAT(DISTINCT CONCAT(a.first_name,' ',a.last_name) ORDER BY CONCAT(a.first_name,' ',a.last_name) DESC SEPARATOR ', ') AS artists
FROM contents AS c
LEFT JOIN artists_by_content AS ac ON c.id_content = ac.id_content
LEFT JOIN artists AS a ON a.id_artist = ac.id_artist
WHERE c.id_content_type = 2
AND c.id_language = 1
AND YEAR(c.pubdate) = 2008
AND c.id_content <>
AND c.active = 1
AND c.deleted = 0
AND a.active = 1
AND a.deleted = 0
AND c.newsletter = 0
GROUP BY c.id_content
ORDER BY c.slot ASC
LIMIT 0,3
kurimanzutto -
